package com.hospital.dao;


import com.hospital.domain.Sit;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SitDao {

    @Select("select * from sitinforinfo where `date` > current_date()")
    public List<Sit> selectAllSit();

    @Insert("insert into sitinforinfo values " +
            "(null,#{dayOfWeek},#{amorPM},#{date})")
    public int addSit(Sit sit);
}
